use "${hmrc_datadir}\CT600\ct600_fame_short.dta" , clear
keep year identifier profits_chargeable_r corp_tax
drop if year<2005|year>2011
duplicates drop
duplicates report identifier year

merge 1:m identifier year using "${hmrc_datadir}\export_reg_final_ukmncs_fy"
keep if _merge==3
drop _merge
gen lntaxable_pi=ln(profits_chargeable)
gen profitability_turnover=profits_chargeable/turnover
gen profitability_asset=profits_chargeable/fixed_asset
save "${hmrc_datadir}\export_reg_final_ukmncs_fy_profitability", replace
